{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Request for Cash","Consolidated Support","CAPER FY23","CAPER FY23 Cum","CAPERList"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":6,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Request for Cash","index":0,"n_rows":68,"n_cols":9,"rows_kept":68,"cut":false,"hidden":false,"merged":[[3,1,3,3],[10,7,10,9],[5,1,5,3],[6,1,6,3],[6,5,6,6],[7,7,7,9],[8,7,8,9],[9,7,9,9],[30,0,32,9],[4,7,4,9],[5,7,5,9],[6,7,6,9],[10,1,10,3],[4,4,4,6],[9,1,9,3],[7,1,7,3],[8,1,8,3],[27,0,27,9],[26,0,26,9],[33,0,33,9],[45,0,45,1],[45,8,45,9],[34,0,36,9],[38,8,38,9],[39,6,39,7],[39,8,39,9],[38,6,38,7],[38,1,38,2],[40,6,40,7],[43,0,43,9],[44,0,44,1],[44,8,44,9],[40,1,40,3]]}
["Mississippi Home Corporation"]
["Request for Cash"]
[]
["Program:","Emergency Solutions Grant Program"]
["Section A:  General Information",null,null,null,"Section B:  Project Information"]
["Recipient",null,null,null,"Grant No.","Contract No.",null,"Project No."]
["Mailing Address",{"$f":"LOOKUP(+$B$6,C52:C68,D52:D68)","v":{"$error":"#N/A"}},null,null,{"$f":"LOOKUP(+$B$6,C52:C68,H52:H68)","v":{"$error":"#N/A"}},{"$f":"LOOKUP(+$B$6,C52:C68,I52:I68)","v":{"$error":"#N/A"}}]
["Street Address",{"$f":"LOOKUP(+$B$6,C52:C68,E52:E68)","v":{"$error":"#N/A"}},null,null,"Services Rendered",null,null,"Request No."]
["City, State Zip",{"$f":"LOOKUP(+$B$6,C52:C68,F52:F68)","v":{"$error":"#N/A"}},null,null,"From",null,"To"]
["Telephone No.",{"$f":"LOOKUP(+$B$6,C52:C68,G52:G68)","v":{"$error":"#N/A"}},null,null,null,"Thru",null,"MHC Staff Initials"]
[]
["Section C:  Request Per Activity"]
[null,null,"Activity Description"," Budget Amount","Total Prior Request to Date","This Request","Remaining Balance","# of Individuals Served","Activity Numbers"]
[1,null,{"$f":"+'Consolidated Support'!B46","v":"Shelter"},{"$f":"+'Consolidated Support'!L46","v":0},{"$f":"+'Consolidated Support'!M8","v":0},{"$f":"+'Consolidated Support'!J46","v":0},{"$f":"+D14-E14-F14","v":0},null,15979]
[2,null,"Street Outreach",{"$f":"+'Consolidated Support'!L59","v":0},{"$f":"+'Consolidated Support'!M48","v":0},{"$f":"+'Consolidated Support'!J59","v":0},0,null,15980]
[3,null,"Rapid Rehousing",{"$f":"+'Consolidated Support'!L83","v":0},{"$f":"+'Consolidated Support'!M61","v":0},{"$f":"+'Consolidated Support'!J83","v":0},0,null,15981]
[4,null,"Homeless Prevention",{"$f":"'Consolidated Support'!L107","v":0},{"$f":"+'Consolidated Support'!M85","v":0},{"$f":"'Consolidated Support'!J107","v":0},0,null,15982]
[5,null,"HMIS",{"$f":"'Consolidated Support'!L120","v":0},{"$f":"+'Consolidated Support'!M109","v":0},{"$f":"'Consolidated Support'!J120","v":0},{"$f":"+D18-E18-F18","v":0},null,15983]
[16,null,null,null,null,null,{"$f":"+D20-E20-F20","v":0}]
[17,null,null,null,null,null,0]
[18,null,null,null,null,null,0]
[20]
[20,null,null,null,null,null,{"$f":"+D23-E23-F23","v":0}]
[null,null,"Total:",{"$f":"SUM(D14:D23)","v":0},{"$f":"SUM(E14:E23)","v":0},{"$f":"SUM(F14:F23)","v":0},{"$f":"SUM(G14:G23)","v":0},{"$f":"SUM(H14:H18)","v":0}]
[]
[]
["Required Accomplishment Narrative "]
[]
[]
[]
["   I Hereby Certify That (a) the services covered by this request have not been received from the Federal Government/State Government or expended for such services under any other contract agreement or grant; (b) the amount requested will be expended for allowable costs / expenditures under the terms of the contract agreement or grant; (c) the amount requested herein does not exceed the total funds obligated by contract; and (d) the funds are requested for only immediate disbursements.  "]
[]
[]
[" By signing this report, I certify to the best of my knowledge and belief that the report is true, complete, and accurate, and the expenditures, disbursements and cash receipts are for the purposes and objectives set forth in the terms and conditions of the Federal award.  I am aware that any false, fictitious, or fraudulent information, or the omission of any material fact, may subject me to criminal, civil or administrative penalties for fraud, false statements, false claims or otherwise (U.S. Code Title 18, Section 1001 and Title 31, Sections 3729-3730 and 3801-3812)."]
["   I Hereby Certify That the goods sold and/or services rendered have been delivered and/or performed in good order within the time listed above and are in compliance with all statutory requirements and regulations.  I certify that this request does not include any advances or funds for future obligations. "]
[]
[]
["Is this your final request for cash on this contract?",null,null,null,null,"YES",null,"NO"]
[]
[null,"           Signature of Authorized Official ",null,null,"Date Signed",null," Prepared By",null,"Date Prepared"]
[]
[null,"Typed Name and Title of Authorized Official",null,null,null,null,"Preparer's Telephone No."]
[]
[]
["IDIS Voucher Number",null,"Vendor Number","Issue/Series","Fund/Sub-Fund","Serviceer"]
[]
[]
[]
[]
[]
[null,null,"Applicant","Mailing Address","Street Address","City","Phone #","Grant No.","Contract No."]
[null,null,"Aids Services Coalition","P. O. Box 169",null,"Hattiesburg, MS  39403",6014504286,2023,"2023-ESG-ASC-23"]
[null,null,"Back Bay Mission",null,"1012 Division Street","Biloxi, MS 39530","(228) 432-0301",2023,"2023-ESG-BBM-23"]
[null,null,"Care Lodge Domestic Violence Shelter","P O Box 5331",null,"Meridian, MS 39302",6014828720,2023,"2023-ESG-CareLodge-23"]
[null,null,"Center for Violence Prevention","PO Box 6279",null,"Pearl, MS 39288 ","(601) 932-4208",2023,"2023-ESG-CVP-23"]
[null,null,"Christians In Action",null,"2025 N Siwell Road","Jackson, MS 39212",6013467119,2023,"2023-ESG-CIA-23"]
[null,null,"Community Care Network ",null,"7400 Fountainblue Road","Ocean Springs, MS 39564",2282202987,2023,"2023-ESG-CCN-23"]
[null,null,"Community Counseling Services ","P O Box 2590",null,"Columbus, MS 39704",6623294333,2023,"2023-ESG-CCS-23"]
[null,null,"Community Development Inc. ","P O Box 689","411 Oak Street","Richton, MS 39476",6017886704,2023,"2023-ESG-CDI-23"]
[null,null,"Domestic Abuse Familly Service","P O Box 273",null,"Laura, MS 39441",6013422362,2023,"2023-ESG-DAFS-23"]
[null,null,"Grace House Inc","P O Box 68924","236 Millsaps Avenue","Jackson, MS 39286",6013531038,2023,"2023-ESG-GHI-23"]
[null,null,"Gulf Coast Center for Non-Violence ","P O Box 333",null,"Biloxi, Mississippi 39533",2284363809,2023,"2023-ESG-GCCNV-23"]
[null,null,"Hancock Resource Center ",null,"454 Highway 90, Suite B","Waveland, MS 39576",2284638887,2023,"2023-ESG-HRC-23"]
[null,null,"Multi-County Community Service Agency ","P O Box 905",null,"Meridian, MS 39302",6014834838,2023,"2023-ESG-MCCSA-23"]
[null,null,"S. A. F. E. ","P O Box 985",null,"Tupelo, MS 38804",6628419105,2023,"2023-ESG-SAFE-23"]
[null,null,"Stewpot Community Services",null,"1100 W. Capitol Street","Jackson, MS ",6013532759,2023,"2023-ESG-SCS-23"]
[null,null,"USM-Institute for Disability Studies",null,"2609 W 4th Street","Hattiesburg, MS  39406",6012664119,2023,"2023-ESG-USMIDS-23"]
[null,null,"WWISCAA, Inc",null,"1538 Old Leland Road","Greenville, MS 38701",6623785857,2023,"2023-ESG-WWISCAA-23"]

{"sheet":"Consolidated Support","index":1,"n_rows":148,"n_cols":14,"rows_kept":148,"cut":false,"hidden":false,"merged":[[0,0,0,13],[1,0,1,13],[129,1,129,4],[147,1,147,4],[146,1,146,4],[146,10,146,11],[136,0,138,13],[140,0,141,13],[131,5,131,8],[134,8,134,9],[133,8,133,9],[144,10,144,11],[145,10,145,11],[142,0,142,13]]}
["Mississippi Home Corporation"]
[" Consolidated Support Sheet"]
[null,"Program:",null,{"$f":"+'Request for Cash'!B4","v":"Emergency Solutions Grant Program"}]
[null,"Recipient",null,{"$f":"+'Request for Cash'!B6","v":0},null,null,null,null,null,null,"Contract Number:",{"$f":"+'Request for Cash'!F7","v":{"$error":"#N/A"}}]
[null,"Request for Cash Number:",null,{"$f":"+'Request for Cash'!H9","v":0},null,null,null,null,null,null,"Total Amount Requested:",{"$f":"+'Request for Cash'!F24","v":0}]
[]
["AWARDS ID","Vendor","Line Items","CAPER Category","Invoice Date","Invoice # / Check #","Date Expense Started","Date Expense Ended","Total Invoice","Amount of This Request","Appendix","Amount Budgeted","Amount Requested to Date","Balance"]
[{"$f":"+'Request for Cash'!I14","v":15979},"Shelter",null,null,null,null,null,null,null,null,null,0,null,{"$f":"+L8-M8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+J9","v":0},{"$f":"+L9-M9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+J10","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Indirect Costs Shelter",null,"ESES- Indirect Cost",null,null,null,null,null,null,null,null,0,0]
[null,{"$f":"+B8","v":"Shelter"},null,null,null,null,null,null,{"$f":"SUM(I8:I45)","v":0},0,null,0,0,0]
[]
[{"$f":"+'Request for Cash'!I15","v":15980},"Street Outreach",null,null,null,null,null,null,null,null,null,0,0,{"$f":"+L48-M48","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+J49","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Indirect Costs SO",null,"SOES- Indirect Cost",null,null,null,null,null,null,null,null,0,0]
[null,{"$f":"+B48","v":"Street Outreach"},null,null,null,null,null,null,{"$f":"SUM(I48:I58)","v":0},0,null,0,0,0]
[]
[{"$f":"+'Request for Cash'!I16","v":15981},"Rapid Re-Housing",null,null,null,null,null,null,null,null,null,0,0,{"$f":"+L61-M61","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+J62","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Indirect Costs RRH",null,"RRSS- Indirect Cost",null,null,null,null,null,null,null,null,0,0]
[null,{"$f":"B61","v":"Rapid Re-Housing"},null,null,null,null,null,null,{"$f":"SUM(I61:I82)","v":0},0,null,0,0,0]
[]
[{"$f":"+'Request for Cash'!I17","v":15982},"Homeless Prevention",null,null,null,null,null,null,null,null,null,0,0,{"$f":"+L85-M85","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+J86","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Indirect Costs HP",null,"HPSS- Indirect Cost ",null,null,null,null,null,null,null,null,0,0]
[null,{"$f":"+B85","v":"Homeless Prevention"},null,null,null,null,null,null,{"$f":"SUM(I85:I106)","v":0},0,null,0,0,0]
[]
[{"$f":"+'Request for Cash'!I18","v":15983},"HMIS",null,null,null,null,null,null,null,null,null,0,0,{"$f":"+L109-M109","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+J110","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Indirect Costs HMIS",null,"HMIS-Indirect Cost",null,null,null,null,null,null,null,null,0,0]
[null,{"$f":"+B109","v":"HMIS"},null,null,null,null,null,null,{"$f":"SUM(I109:I119)","v":0},0,null,0,0,0]
[]
[null,"MATCH",null,null,null,null,null,null,null,null,"MATCH Value $"]
[]
[]
[]
[]
[]
[null,{"$f":"+B122","v":"MATCH"},null,null,null,null,null,null,null,null,{"$f":"SUM(K117:K127)","v":0}]
[]
[null,"GRAND TOTAL",null,null,null,null,null,null,{"$f":"I59+I120+I107+I83+I46","v":0},{"$f":"J59+J120+J107+J83+J46","v":0},{"$f":"+K128","v":0},{"$f":"L59+L120+L107+L83+L46","v":0},{"$f":"M59+M120+M107+M83+M46","v":0},{"$f":"N59+N120+N107+N83+N46","v":0}]
[]
[null,"Services Rendered - Beginning:",null,null,null,{"$f":"'Request for Cash'!E10","v":"00:00:00"},null,null,null,"Thru",{"$f":"+'Request for Cash'!G10","v":"00:00:00"}]
[]
[null,null,null,null,{"$f":"+M130","v":0},"Plus (+)",null,null,{"$f":"+K130","v":0},null,"Equals (=)",{"$f":"+E134+I134","v":0}]
[null,"Cumulative:  ",null,null,"Program Expenditures ",null,null,null,"Matching Expenditures",null,null,"Total Expenditures"]
[]
["   I Hereby Certify That (a) the services covered by this request have not been received from the Federal / State Government or expended for such services under any other contract agreement or grant; (b) the amount requested will be expended for allowable costs / expenditures under the terms of the contract agreement or grant; (c) the amount requested herein does not exceed the total funds obligated by contract; and (d) the funds are requested for only immediate disbursements."]
[]
[]
[]
["   I Hereby Certify That the goods sold and/or services rendered have been delivered and/or performed in good order within the time listed above and are in compliance with all statutory requirements and regulations.  I certify that this request does not include any advances or funds for future obligations."]
[]
[" By signing this report, I certify to the best of my knowledge and belief that the report is true, complete, and accurate, and the expenditures, disbursements and cash receipts are for the purposes and objectives set forth in the terms and conditions of the Federal award.  I am aware that any false, fictitious, or fraudulent information, or the omission of any material fact, may subject me to criminal, civil or administrative penalties for fraud, false statements, false claims or otherwise (U.S. Code Title 18, Section 1001 and Title 31, Sections 3729-3730 and 3801-3812)."]
[]
[null,null,null,null,null,null,null,null,{"$f":"+'Request for Cash'!E39","v":"00:00:00"},null,{"$f":"+'Request for Cash'!G39","v":0}]
[null,"Signature of Authorized Official ",null,null,null,null,null,null,"Date Signed",null," Prepared By"]
[null,{"$f":"+'Request for Cash'!B41","v":0},null,null,null," ",null,null,null,null,{"$f":"+'Request for Cash'!G41","v":0}]
[null,"          Typed Name and Title of Authorized Official",null,null,null,null,null,null,null,null,"Preparer's Telephone No."]

{"sheet":"CAPER FY23","index":2,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[[24,0,24,2],[7,0,7,2],[12,0,12,2],[18,0,18,2],[31,0,31,2],[5,1,5,2],[0,0,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2]]}
[" Financial Summary Report (CAPER)"]
["Sub recipient",{"$f":"+'Request for Cash'!B6","v":0}]
["Contract Number",{"$f":"+'Request for Cash'!F7","v":{"$error":"#N/A"}}]
["Request for Cash Number",{"$f":"'Request for Cash'!H9","v":0}]
["Reporting Period From",{"$f":"'Request for Cash'!E10","v":"00:00:00"}]
["                            To",{"$f":"'Request for Cash'!G10","v":"00:00:00"}]
[null,null,"Emergency Solutions Grant Expenditures by Categories "]
["ESG Expenditures for Emergency Shelter"]
["Essential Services",null,{"$f":"SUMIF('Consolidated Support'!D9:D45,\"ESES*\",'Consolidated Support'!M9:M45)","v":0}]
["Operations",null,{"$f":"SUMIF('Consolidated Support'!D9:D45,\"ESOP*\",'Consolidated Support'!M9:M45)","v":0}]
["Subtotal",null,{"$f":"SUM(C9:C10)","v":0}]
[]
["ESG Expenditures for Rapid Rehousing"]
["Expenditures for Rental Assistance",null,{"$f":"SUMIF('Consolidated Support'!D62:D82,\"RRRA*\",'Consolidated Support'!M62:M82)","v":0}]
["Expenditures for Housing Relocation and Stabilization Services - Financial Assistance",null,{"$f":"SUMIF('Consolidated Support'!D62:D82,\"RRFA*\",'Consolidated Support'!M62:M82)","v":0}]
["Expenditures for Housing Relocation and Stabilization Services - Services",null,{"$f":"SUMIF('Consolidated Support'!D62:D82,\"RRSS*\",'Consolidated Support'!M62:M82)","v":0}]
["Subtotal Rapid Rehousing",null,{"$f":"SUM(C14:C16)","v":0}]
[]
["ESG Expenditures for Homelessness Prevention"]
["Expenditures for Rental Assistance",null,{"$f":"SUMIF('Consolidated Support'!D86:D106,\"HPRA*\",'Consolidated Support'!M86:M106)","v":0}]
["Expenditures for Housing Relocation and Stabilization Services - Financial Assistance",null,{"$f":"SUMIF('Consolidated Support'!D86:D106,\"HPFA*\",'Consolidated Support'!M86:M106)","v":0}]
["Expenditures for Housing Relocation and Stabilization Services - Services",null,{"$f":"SUMIF('Consolidated Support'!D86:D106,\"HPSS*\",'Consolidated Support'!M86:M106)","v":0}]
["Subtotal Homelessness Prevention",null,{"$f":"SUM(C20:C22)","v":0}]
[]
["Other Grant Expenditures"]
["Street Outreach",null,{"$f":"SUMIF('Consolidated Support'!D49:D58,\"SOES*\",'Consolidated Support'!M49:M58)","v":0}]
["HMIS",null,{"$f":"SUMIF('Consolidated Support'!D110:D119,\"HMIS*\",'Consolidated Support'!M110:M119)","v":0}]
["Administration"]
[]
["Total ESG Grant Funds",null,{"$f":"+C28+C27+C26+C11+C17+C23","v":0}]
[]
["Match Source"]
["Other Non-ESG HUD funds",null,{"$f":"SUMIF('Consolidated Support'!D123:D127,\"MATCH-Other Non-ESG Funds*\",'Consolidated Support'!K123:K127)","v":0}]
["Other Federal Funds",null,{"$f":"SUMIF('Consolidated Support'!D123:D127,\"MATCH-Other Federal Funds*\",'Consolidated Support'!K123:K127)","v":0}]
["State Government ",null,{"$f":"SUMIF('Consolidated Support'!D123:D127,\"MATCH-State Government*\",'Consolidated Support'!K123:K127)","v":0}]
["Local Government ",null,{"$f":"SUMIF('Consolidated Support'!D123:D127,\"MATCH-Local Government*\",'Consolidated Support'!K123:K127)","v":0}]
["Private Funds",null,{"$f":"SUMIF('Consolidated Support'!D123:D127,\"MATCH-Private Funds*\",'Consolidated Support'!K123:K127)","v":0}]
["Other Volunteer Hours",null,{"$f":"SUMIF('Consolidated Support'!D123:D127,\"MATCH-Other Volunteer Hours*\",'Consolidated Support'!K123:K127)","v":0}]
["Other In-Kind",null,{"$f":"SUMIF('Consolidated Support'!D123:D127,\"MATCH-In-Kind Donations*\",'Consolidated Support'!K123:K127)","v":0}]
["Other-Donated value___________________________________",null,{"$f":"SUMIF('Consolidated Support'!D123:D127,\"MATCH-Other-Donated value*\",'Consolidated Support'!K123:K127)","v":0}]
["Total Match Amount",null,{"$f":"SUM(C33:C40)","v":0}]
[]
["Total ESG Funds Expended",null,{"$f":"+C41+C30","v":0}]

{"sheet":"CAPER FY23 Cum","index":3,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[[31,0,31,2],[0,0,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[7,0,7,2],[12,0,12,2],[18,0,18,2],[24,0,24,2]]}
["Cumulative Financial Summary Report (CAPER)"]
["Sub recipient",{"$f":"'Request for Cash'!B6:D6","v":0}]
["Contract Number",{"$f":"'Request for Cash'!F7","v":{"$error":"#N/A"}}]
["Request for Cash Number",{"$f":"'Consolidated Support'!D5","v":0}]
["Reporting Period From",{"$f":"'Request for Cash'!E10","v":"00:00:00"}]
["                            To",{"$f":"'Request for Cash'!G10","v":"00:00:00"}]
[null,null,"Emergency Solutions Grant Expenditures by Categories   12/22/23 to 12/21/24"]
["ESG Expenditures for Emergency Shelter"]
["Essential Services",null,0]
["Operations",null,0]
["Subtotal",null,{"$f":"SUM(C9:C10)","v":0}]
[]
["ESG Expenditures for Rapid Rehousing"]
["Expenditures for Rental Assistance",null,0]
["Expenditures for Housing Relocation and Stabilization Services - Financial Assistance",null,0]
["Expenditures for Housing Relocation and Stabilization Services - Services",null,0]
["Subtotal Rapid Rehousing",null,{"$f":"SUM(C14:C16)","v":0}]
[]
["ESG Expenditures for Homelessness Prevention"]
["Expenditures for Rental Assistance",null,0]
["Expenditures for Housing Relocation and Stabilization Services - Financial Assistance",null,0]
["Expenditures for Housing Relocation and Stabilization Services - Services",null,0]
["Subtotal Homelessness Prevention",null,{"$f":"SUM(C20:C22)","v":0}]
[]
["Other Grant Expenditures"]
["Street Outreach",null,0]
["HMIS",null,0]
["Administration",null,0]
[]
["Total ESG Grant Funds",null,{"$f":"+C28+C27+C26+C11+C17+C23","v":0}]
[]
["Match Source"]
["Other Non-ESG HUD funds",null,0]
["Other Federal Funds",null,0]
["State Government ",null,0]
["Local Government ",null,0]
["Private Funds",null,0]
["Other Volunteer Hours",null,0]
["Other In-Kind",null,0]
["Other Type___________________________________",null,0]
["Total Match Amount",null,{"$f":"SUM(C33:C40)","v":0}]
[]
["Total ESG Funds Expended",null,{"$f":"+C41+C30","v":0}]

{"sheet":"CAPERList","index":4,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[]
["Category","SubCategory1","Category-SubCategory1","SubCategory2",null,"Eligible Items"]
["Emergency Shelter","Essential Services","ESES","ESES-Case management",null,"Case management"]
["Emergency Shelter","Essential Services","ESES","ESES-Transportation",null,"Transportation"]
["Emergency Shelter","Essential Services","ESES","ESES- Indirect Costs",null,"Indirect Cost"]
["Emergency Shelter","Essential Services","ESES","ESES- Child Care",null,"Child Care"]
["Emergency Shelter","Essential Services","ESES","ESES- Education Services",null,"Education Services"]
["Emergency Shelter","Essential Services","ESES","ESES- Employment Assistance & Job Training",null,"Employment Assistance & Job Training"]
["Emergency Shelter","Essential Services","ESES","ESES- Outpatient Health Services",null,"Outpatient Health Services"]
["Emergency Shelter","Essential Services","ESES","ESES- Legal Services",null,"Legal Services"]
["Emergency Shelter","Essential Services","ESES","ESES- Life Skills Training",null,"Life Skills Training"]
["Emergency Shelter","Essential Services","ESES","ESES- Mental Health Services",null,"Mental Health Services"]
["Emergency Shelter","Essential Services","ESES","ESES- Substance Abuse Treatment Services",null,"Substance Abuse Treatment Services"]
["Emergency Shelter","Operations","ESOP","ESOP-Maintenance",null,"Maintenance"]
["Emergency Shelter","Operations","ESOP","ESOP-Case Management/Staff Cost",null,"Case Management/Staff Cost"]
["Emergency Shelter","Operations","ESOP","ESOP-Rent",null,"Rent"]
["Emergency Shelter","Operations","ESOP","ESOP-Security",null,"Security"]
["Emergency Shelter","Operations","ESOP","ESOP-Fuel",null,"Fuel"]
["Emergency Shelter","Operations","ESOP","ESOP-Equipment",null,"Equipment"]
["Emergency Shelter","Operations","ESOP","ESOP-Insurance/Professional Services",null,"Insurance/Professional Services"]
["Emergency Shelter","Operations","ESOP","ESOP-Utilities",null,"Utilities"]
["Emergency Shelter","Operations","ESOP","ESOP-Food",null,"Food"]
["Emergency Shelter","Operations","ESOP","ESOP-Furnishings",null,"Furnishings"]
["Emergency Shelter","Operations","ESOP","ESOP-Supplies for shelter",null,"Supplies for shelter"]
["Emergency Shelter","Operations","ESOP","ESOP-Hotel/Motel Vouchers",null,"Hotel/Motel Vouchers"]
["Street Outreach","Essential Services","SOES","SOES-Engagement",null,"Cost of locating, identifying and building relationships and engaging with unsheltered homeless people for the purpose of providing assistance."]
["Street Outreach","Essential Services","SOES","SOES-Case Management",null,"Assessing housing & service needs, arranging, coordinating, and monitoring the delivery of individualized services to meet the needs of the program participant."]
["Street Outreach","Essential Services","SOES","SOES- Indirect Costs",null,"Indirect Cost"]
["Street Outreach","Essential Services","SOES","SOES-Emergency Health Services",null,"Direct outpatient treatment of medical conditions provided by licensed medical professionals operating in the community-based settings."]
["Street Outreach","Essential Services","SOES","SOES-Emergency Mental Health Services",null,"Direct outpatient treatment by licensed professionals"]
["Street Outreach","Essential Services","SOES","SOES-Transportation",null,"Cost of travel by outreach workers, social workers, medical professionals or other service providers.  To transport unsheltered people to shelters and other service facilities."]
["Street Outreach","Essential Services","SOES","SOES-Special Population",null,"Homeless youth; victim services and services for people living with HIV/AIDS"]
["Rapid Rehousing","Expenditures for Rental Assistance","RRRA","RRRA-Rental payment",null,"Rental payment"]
["Rapid Rehousing","Expenditures for Rental Assistance","RRRA","RRRA-Rental arrearage payment",null,"Rental arrearage payment"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","RRFA","RRFA-Rental application fees",null,"Rental application fees"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","RRFA","RRFA-Security deposits",null,"Security deposits"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","RRFA","RRFA-Last month rent",null,"Last month rent"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","RRFA","RRFA-Utility deposit",null,"Utility deposit"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","RRFA","RRFA-Utility payment",null,"Utility payment"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","RRFA","RRFA-Moving costs",null,"Moving costs"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Services","RRSS","RRSS-Housing stability case management",null,"Housing stability case management"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Services","RRSS","RRSS-Housing search",null,"Housing search"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Services","RRSS","RRSS-Placement",null,"Placement"]
["Rapid Rehousing","Expenditures for Housing Relocation and Stabilization Services - Services","RRSS","RRSS- Indirect Costs",null,"Indirect Cost"]
["Homeless Prevention","Expenditures for Rental Assistance","HPRA","HPRA-Rental payment",null,"Rental payment"]
["Homeless Prevention","Expenditures for Rental Assistance","HPRA","HPRA-Rental arrearage payment",null,"Rental arrearage payment"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","HPFA","HPFA-Rental application fees",null,"Rental application fees"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","HPFA","HPFA-Security Deposit",null,"Security Deposit"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","HPFA","HPFA-Last month rent",null,"Last month rent"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","HPFA","HPFA-Utility deposit",null,"Utility deposit"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","HPFA","HPFA-Utility payment",null,"Utility payment"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Financial Assistance","HPFA","HPFA-Moving Cost",null,"Moving Cost"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Services","HPSS","HPSS-Housing stability case management",null,"Housing stability case management"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Services","HPSS","HPSS-Housing search",null,"Housing search"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Services","HPSS","HPSS-Placement",null,"Placement"]
["Homeless Prevention","Expenditures for Housing Relocation and Stabilization Services - Services","HPSS","HPSS- Indirect Costs",null,"Indirect Cost"]
["HMIS","Homeless Management Information System","HMIS","HMIS-Data support",null,"Data support"]
["HMIS","Homeless Management Information System","HMIS","HMIS-Indirect Costs",null,"Indirect Cost"]
["MATCH","Other Non-ESG HUD funds","MATCH-Other Non-ESG Funds","MATCH-Other Non-ESG Funds",null,"Other Non-ESG Funds"]
["MATCH","Other Federal Funds","MATCH-Other Federal Funds","MATCH-Other Federal Funds",null,"Other Federal Funds"]
["MATCH","State Government","MATCH-State Government","MATCH-State Government",null,"State Government"]
["MATCH","Local Government","MATCH-Local Government","MATCH-Local Government",null,"Local Government"]
["MATCH","Private Funds","MATCH-Private Funds","MATCH-Private Funds",null,"Private Funds"]
["MATCH","Other-Volunteer Hours","MATCH-Other Volunteer Hours","MATCH-Other Volunteer Hours",null,"Other Volunteer Hours"]
["MATCH","Other-In Kind Donations","MATCH-In-Kind Donations","MATCH-In-Kind Donations",null,"Other-In Kind Donations"]
["MATCH","Other-Donated value","MATCH-Other-Donated value","MATCH-Other-Donated value",null,"Other-Donated value"]